UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OiPk60DUIzN0FC8miicFxrDDkf3f15YN2AvZToys+vY='
WHERE
key_id = 'a0b4c491d805045d31d79c632ae7bfef5989fa17d7fb44c59fd9ba41bcebc0b6'
AND (
token = 'OiPk60DUIzN0FC8miicFxrDDkf3f15YN2AvZToys+vY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)