UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DGIDVflH6x1dMNGHZvh6AVNNT9cvX6gQzmeawi8tcT0='
WHERE
key_id = '874acb5e24bd5ff5fedfaf37818b2403d01ad223f2ab6328681967828a0311ff'
AND (
token = 'DGIDVflH6x1dMNGHZvh6AVNNT9cvX6gQzmeawi8tcT0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)