UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WGtEoLV2bRQNpqIPW+Imps4zVyBwKSYlPAuUv6gAJTo='
WHERE
key_id = 'c1341bab4d8fdfd56121ab1158ba7ffd9a817ed4a137e7c966a077ab7928fbe9'
AND (
token = 'WGtEoLV2bRQNpqIPW+Imps4zVyBwKSYlPAuUv6gAJTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)