UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQGKLbDyFhiPffF8W6zU91wAImuHWEaMsWoc7EK4x/I='
WHERE
key_id = 'a1591862b3d759412a2531b4d84afd570ee445c02fb10fa4f20de1af3190ea21'
AND (
token = 'hQGKLbDyFhiPffF8W6zU91wAImuHWEaMsWoc7EK4x/I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)