UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kn4hprYfQ023Tjz/gZfoMayXoPu+g/geJ+4yTt4/TIA='
WHERE
key_id = 'df754971d5e98547b449c82ab21a301fac3a8bd729bbdf8ab98ed81d128567c7'
AND (
token = 'kn4hprYfQ023Tjz/gZfoMayXoPu+g/geJ+4yTt4/TIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)