UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HsrHnHf1Tku7Uue2EoSvoOw1y4zP10cW4jlYo+48fAo='
WHERE
key_id = '228f5ab5de73227b61e94c851a425901e659f39a116c3fde6f114eca5e588a72'
AND (
token = 'HsrHnHf1Tku7Uue2EoSvoOw1y4zP10cW4jlYo+48fAo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)