UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nfP/QNv+NDjzM+iYSPgvft5bNyJFe9WQBlXd6R/+9tk='
WHERE
key_id = 'b78ac6b8a93fee1dc738612b441a22aa2dddb44334fc3f746ba20d28464bc496'
AND (
token = 'nfP/QNv+NDjzM+iYSPgvft5bNyJFe9WQBlXd6R/+9tk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)