UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zm9HuAz1FxHWPIVNp6j2A1gWuRqSXCHm/jhZEsYt4U8='
WHERE
key_id = '4ddd646bad31476d8439ebbf70f6dc3585e26e7724fcc5f4a3016fa9c7e1e48f'
AND (
token = 'Zm9HuAz1FxHWPIVNp6j2A1gWuRqSXCHm/jhZEsYt4U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)