UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vTp49lPJsTKw+F2Gn6Y07URxwz/g+EyFNGq9nTRLGls='
WHERE
key_id = 'ee0dc77f37641c56fb09ae7247e41d7265b975095fae9270a8d89f00618b18a7'
AND (
token = 'vTp49lPJsTKw+F2Gn6Y07URxwz/g+EyFNGq9nTRLGls='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)