UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9VvQougA+v9nM0Z0zz5Ga7r1SUYWI9Jzj3IpydKTR0='
WHERE
key_id = 'dc1f5f70d298b2eae8a4014165af22ec8502a0ffbf52c59606ed79d0a569c448'
AND (
token = 'd9VvQougA+v9nM0Z0zz5Ga7r1SUYWI9Jzj3IpydKTR0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)