UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HpqQonZ3ADX59fESMOB3D+GSdxZySW5NZJKoQQ3iOfE='
WHERE
key_id = 'cd93bca27d8d5683bee54f8e6ba4f219fe9601c5110586b2e58e83a1b9fd0b7b'
AND (
token = 'HpqQonZ3ADX59fESMOB3D+GSdxZySW5NZJKoQQ3iOfE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)