UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WKZsGcKhuqNxg3FrplCV33QF6LUHoxMiu5uX6B5Du9M='
WHERE
key_id = '2b378a381b639bd500d342a61fed597df30ee5de8015fad82ff701c83ebe23c8'
AND (
token = 'WKZsGcKhuqNxg3FrplCV33QF6LUHoxMiu5uX6B5Du9M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)