UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7bRjDfKYsC2cYIX8a0a3diBZ+T+DFfZPbL+Sx1N9SAs='
WHERE
key_id = 'f4dbde8d1166a304cdd8340ee0d71a2fcc23ce411340acc0f4f58cb5743b718f'
AND (
token = '7bRjDfKYsC2cYIX8a0a3diBZ+T+DFfZPbL+Sx1N9SAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)