UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QoRFLLjLI0GfBQ1abG7CD2YRBfXs/Ukvc+XeRflKee0='
WHERE
key_id = 'e142801c7d0c94ab9ffdedbe0104a04e8c6c331500592dcec33085bdb410fbec'
AND (
token = 'QoRFLLjLI0GfBQ1abG7CD2YRBfXs/Ukvc+XeRflKee0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)