UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oWnDz5ng0sqL2sXsKjuaNoz+UPG5dMrZzMCSX2CJvSk='
WHERE
key_id = 'b63f1634fdca5ac07281a21ffadf6f91c88550c0ddab0b635b4f75be318cca5d'
AND (
token = 'oWnDz5ng0sqL2sXsKjuaNoz+UPG5dMrZzMCSX2CJvSk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)