UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wlo16r4RlNl4an0lJnuqQ7iXCwK16aWtevpHbX0tfWU='
WHERE
key_id = 'c8d3acfce2dc9d520cfd5769e3ef60bcec7b509a7866a76fe97939c38f112340'
AND (
token = 'wlo16r4RlNl4an0lJnuqQ7iXCwK16aWtevpHbX0tfWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)