UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3nimdDMIbpI4ks1T5WLVzBLlVnIfeDqkbYEG9uZmO5o='
WHERE
key_id = '31db268770eb98ac669583460107d02b758718774ec7b69f569b8bee2cbee033'
AND (
token = '3nimdDMIbpI4ks1T5WLVzBLlVnIfeDqkbYEG9uZmO5o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)