UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8y1OcYINvai6FkCmeZzyR+Sr+1tGrs7jFUg+MgFDomw='
WHERE
key_id = 'a7d00ed1f928296955730c24723ccfb42445a33746bfb18c2ad15108e8d74824'
AND (
token = '8y1OcYINvai6FkCmeZzyR+Sr+1tGrs7jFUg+MgFDomw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)