UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3XVaWsL6qZMNNSqh9GWeKJ23zDDh5xzlasIVTrFG7cw='
WHERE
key_id = '4ac9e52cf258b66142d7971747024315a16d0f880a548291116ebcc525488e9b'
AND (
token = '3XVaWsL6qZMNNSqh9GWeKJ23zDDh5xzlasIVTrFG7cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)