UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zC2hmTDj7aAHjEVPtsQVaCU0LIST64fkWV4Im7c+90='
WHERE
key_id = '6c3d9d442a4f6ced19dac48a97a568238e491afcee6bfcef86d52860f7955227'
AND (
token = '0zC2hmTDj7aAHjEVPtsQVaCU0LIST64fkWV4Im7c+90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)