UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NsoI+fUSoE8oCE+89cL+avIvQ7WkPnDjj2WZpXgxwH4='
WHERE
key_id = 'bb14309f962493cbdf9de92a5c6f32a948f898ca79c0e7a949b07ab83d07357b'
AND (
token = 'NsoI+fUSoE8oCE+89cL+avIvQ7WkPnDjj2WZpXgxwH4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)