UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WVE+VYcVksoff9yJreYQYHE+nnINnP1EVVWjv5SsDdA='
WHERE
key_id = 'a46e785380fb5795eee688207fa840fe9ca8789eea9ca31523e37b3f553b7043'
AND (
token = 'WVE+VYcVksoff9yJreYQYHE+nnINnP1EVVWjv5SsDdA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)