UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DTHV8x0NKmua+9hUTpsG5u2tHY3eFBde+vkWIdoVBVg='
WHERE
key_id = 'a22910abc7d33a9404f31966368c25f5c25115b73b3060e42a9f59c2c4439c73'
AND (
token = 'DTHV8x0NKmua+9hUTpsG5u2tHY3eFBde+vkWIdoVBVg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)