UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WgfTvn66BHYwEl8dpEVYF6uRWBWaWfP7U7F/H0Z/k0w='
WHERE
key_id = '3bf7d311b858a135e8d2de2781eb5152196900cd71f3e4eca7c2a0a485ded556'
AND (
token = 'WgfTvn66BHYwEl8dpEVYF6uRWBWaWfP7U7F/H0Z/k0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)