UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xVukIz+nNpasfI/svQk3zqGwzoV7oQKrHm6HXwmHnZA='
WHERE
key_id = 'ec3d8d929953e1c53730c515fbe2ce3b123f2eae457f4967c9bc9da1cdf00cbc'
AND (
token = 'xVukIz+nNpasfI/svQk3zqGwzoV7oQKrHm6HXwmHnZA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)