UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cqIRZM/Lxmv6SkfpyWnbnrlgoGUh+0G+AVZTNJGC4kw='
WHERE
key_id = 'bfb42c29caf1ebe300173d0fb454f2d62d09813c37d78b8d1d42dbc58da467af'
AND (
token = 'cqIRZM/Lxmv6SkfpyWnbnrlgoGUh+0G+AVZTNJGC4kw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)