UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gvMLFF0VHMu9ZnOH7Z/6yuZatgjkUmaqVBc5CjgTBd4='
WHERE
key_id = '9784ada7662f631ee5fb0ba01fc6e582ad91d4f305361f2b33e4c37f6df7aef0'
AND (
token = 'gvMLFF0VHMu9ZnOH7Z/6yuZatgjkUmaqVBc5CjgTBd4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)