UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vU2PaCTTZbMU+s12CeRUAXOs6UcC0Hdg7dZ35GfDPa8='
WHERE
key_id = 'a978980fce6775504292cf9f23225d27913cb18be292ec412de3ba0b3b859fa2'
AND (
token = 'vU2PaCTTZbMU+s12CeRUAXOs6UcC0Hdg7dZ35GfDPa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)