UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SoP7mvtd0zk9DBEdZKbU4jlbs5a2u7rAmiJU1Hr1iqk='
WHERE
key_id = 'ae339171b8aee0c6f2306c70d30f7c688e0ff44f14b85120cb83168997941072'
AND (
token = 'SoP7mvtd0zk9DBEdZKbU4jlbs5a2u7rAmiJU1Hr1iqk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)