UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kCcbinoZSdQv7PsM0ePkRPEF1SLo/9ykoxyb4O4OESg='
WHERE
key_id = 'bb980bd5a712cb998b2b39a7c979dd4ac4d44712da13106b8148a6bce6a1eadc'
AND (
token = 'kCcbinoZSdQv7PsM0ePkRPEF1SLo/9ykoxyb4O4OESg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)