UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3lcgJ1bQxd2wWNwiVv/P9s6yO/Hv/ZHrzxBtPZjAyS0='
WHERE
key_id = 'd456aa17baab94caf2142729380988a93e7a0b4fa6954088ac431431b718ff25'
AND (
token = '3lcgJ1bQxd2wWNwiVv/P9s6yO/Hv/ZHrzxBtPZjAyS0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)