UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B5nyrkQT5PdU/ozOiZO+V5xbDHGc7SDl0cTkrBNFfog='
WHERE
key_id = 'd0d7afdba060f70b590d85ab12d9c233c1f604b67c825b3a7930f2734a5e7045'
AND (
token = 'B5nyrkQT5PdU/ozOiZO+V5xbDHGc7SDl0cTkrBNFfog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)