UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2Z/C4TKLOkj7PJ7Xh4n1qUs3+BzLb5z9x24UVKd8zyw='
WHERE
key_id = 'c8d811258295094068748d4e0c4426fde64d44e27e28743d9cce6ae13fac63aa'
AND (
token = '2Z/C4TKLOkj7PJ7Xh4n1qUs3+BzLb5z9x24UVKd8zyw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)