UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2vjb5wrEs4gmC/G0g+56WLzPHmoKlDEY8vN5rfLusF8='
WHERE
key_id = '7119acae6fdfc21a9eef1750f05bee136536c991f99348307a527089566b543f'
AND (
token = '2vjb5wrEs4gmC/G0g+56WLzPHmoKlDEY8vN5rfLusF8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)