UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xy3PzX5YAXtSBYgestnvx9EPjomySgM2RUa0obijqiU='
WHERE
key_id = '99ac41414431e7d94f0550585ebb64f550d581c061fabfd72de77b6bc4ffcb38'
AND (
token = 'xy3PzX5YAXtSBYgestnvx9EPjomySgM2RUa0obijqiU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)