UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W2Crh9b467VMSf4oSrxwoavIAt4We5vlHxY+avRGB3w='
WHERE
key_id = 'c4a50fbcf3e4454ccbe092191707d386b6cba710e6a4945de19097aae6b8d0d6'
AND (
token = 'W2Crh9b467VMSf4oSrxwoavIAt4We5vlHxY+avRGB3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)