UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PZ3QQPdwwpMtDT09iSPxzhlywBoerk+R8FPy015VtPI='
WHERE
key_id = '0e9f678f6ddd97473a33ce0e4851063e8aa7bf60444be590724b612580be60ef'
AND (
token = 'PZ3QQPdwwpMtDT09iSPxzhlywBoerk+R8FPy015VtPI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)