UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mcMh0enX0uHxcqlUbUpdRXDwUC7g2C5m36b+/IFalnU='
WHERE
key_id = '1795cfe461ea1778b81b36038c4de219938e21941d6d25882d7daf6ceeeee360'
AND (
token = 'mcMh0enX0uHxcqlUbUpdRXDwUC7g2C5m36b+/IFalnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)