UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6yy/YRbVI83X2fe0EnezKs0ro0zknswEznpvoq9v4LU='
WHERE
key_id = '8f8414d94886ad87b637fb01ccba8059f7e0f8dd05cfcff2eb620de963a6cc91'
AND (
token = '6yy/YRbVI83X2fe0EnezKs0ro0zknswEznpvoq9v4LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)