UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QLygJFSqz+YjR26DpCO3m7VW594aFNObthWth+UHgJc='
WHERE
key_id = '0e31e5696a0bfd30974642290b636591cc14887aa6acf10030a7d343c26f50ac'
AND (
token = 'QLygJFSqz+YjR26DpCO3m7VW594aFNObthWth+UHgJc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)