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