UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jD0msSGJNOSYiP8s9i4HzLicihV9pkpX1/nDm+k2ZUU='
WHERE
key_id = '0526d1e888b01326f52c8826693cfb01c3891da2c644980d98bd243b502fa702'
AND (
token = 'jD0msSGJNOSYiP8s9i4HzLicihV9pkpX1/nDm+k2ZUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)