UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yoP5DvSoyrVtcuk6N6wZaN642LlQ+cHvgpvq3XGhgg='
WHERE
key_id = '52646863627f13beb9c2e3d94e12be98057b13ae2285d1e648f89325d8034b17'
AND (
token = '9yoP5DvSoyrVtcuk6N6wZaN642LlQ+cHvgpvq3XGhgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)